Defining Replicate data source connections

You can also generate the model by discovering the source database in the Replicate task. In this case, you will also need to define connectivity to that database.

To define connectivity settings:

1. Open your project and click Manage in the Databases panel. The Manage Databases window opens.

2. Click the New toolbar button. The New Data Source window opens.

3. In the New Data Source window, select the Source database connection option.

4. Continue from one of the following topics as appropriate:

   • Using Oracle as a source
   • Using Microsoft SQL Server as a source
   • Using MySQL as a source
   • Using IBM DB2 for LUW as a source